USE [comunion]
GO

/****** Object:  StoredProcedure [dbo].[rsp_Transaction_WRR_Details]    Script Date: 06/18/2010 15:53:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO








--Stored Procedure for Transactional Printout (Warehouse Receiving Report - Details)
CREATE   PROCEDURE [dbo].[rsp_Transaction_PurchaseInvoice_Details]
	@cTranNo VARCHAR(25),
	@cCompID VARCHAR(10)

AS 

	SELECT A.cRefNo, A.cItemNo, A.cDesc, A.cUnit, A.nQty, A.nPrice, A.nAmount,A.cLongDesc
	FROM PURCHASE_T A
	WHERE A.cTranNo = @cTranNo AND A.cCompanyID = @cCompID
	





GO


